postgresql sync

PostgreSQL Hardware Performance Tuning Translated from the article "PostgreSQL Hardware performance Tuning" PostgreSQL is an object-relational database developed by developers all over the world on the Internet. She is an open source

The first section creates multiple PostgreSQL instances on a single hostStep One: Install the PostgreSQL softwareInstall PostgreSQL instances, download PostgreSQL installation software from the PostgreSQL website https://www.postgresql.org/ , unzip,

We know that the information in the PostgreSQL database is ultimately written to the persistent device. So how does PostgreSQL store the information organization on disk? Bruce Momjian has a slide "insider PostgreSQL Shared Memory", inside the

I. Hosts and topology structure of PG cluster1.host infosCLUSTER01_NODE01 192.168.0.108CLUSTER01_NODE02 192.168.0.109CLUSTER02_NODE03 192.168.0.1102.topology structure sync asyncPrimary (CLS01_NODE01)--

Use Bucardo5 to implement master database replication of PostgreSQL, bucardo5postgresql The next generation of asynchronous primary database replication system Bucardo 5 is released. This version removes the restrictions on two database sources in

2.3 Understanding consistency and data lossIt is not possible to mine PostgreSQL transaction logs without regard to consistency. In the first part of this chapter, we have largely explained the basic idea of the transaction log. You already know

The next generation asynchronous multiple primary database replication System Bucardo 5 was released. This version removes the limit of two database sources in the old version, allowing for more source databases (that is, the primary database) and

Catalogue [-] One, high availability, load balancing, replication of several scenarios comparison: Two, multi-node cluster scheme comparison 9.3 Official Document (Chinese):

From: http://bbs.chinaunix.net/thread-955564-1-1.html Reference documentsHttp://bbs.chinaunix.net/viewthr ... page%3d1#pid6997819Http://topic.csdn.net/t/20050617/12/4089010.htmlPostgreSQL Data SynchronizationSLONY1 is a replication technology based

Test data of PostgreSQL running on FreeBSD and Linux This afternoon I wanted to test DragonFly dports. I suddenly wondered why I didn't compare the performance difference between PostgreSQL in BSD and Linux. For this reason, I set some standards to